Quantile Band
Use the Quantile Band tool to distribute a numeric column’s values into evenly sized bands. You can add a filter to refine the results, and you can make the resulting column permanent.
Procedure
- Drag the
Quantile Band
tool to the Workspace.
- Choose the join operator.
- Click the icon to the right of the
New Quantile Band field.
- Enter a name for the Quantile Band in the
Display Name
field. If you save the tool as a template, this name will be used to display it in the
Templates tab. The Display Name is also used in the Caption area if you insert the tool into a document
- If you want the new column to be automatically indexed, select the
Index Column check box. You should only index columns when necessary. For example, when engineered columns have > 250 discrete values, indexing can start to improve query performance.
| Note: |
The default value for the
Index Column check box is unselected. If you import a Campaign Manager document with the
Index Column check box selected, the check box will revert to unselected. This is because when you import an existing engineering node, you are effectively creating a new one and the check box default of unselected is applied. |
- Optional setting: if you want to make the fields permanent, click the
Optional expand icon. In the
Table Column Name field, enter the name you want to use to display the column in the
Data Explorer tab.
- Configure the remaining
Settings fields:
- Numeric Source Column: Drag in a column that will provide the basis of the quantile bands.
- Filter Segment:
Use this field to apply filters to the original column to create a subset of records.
- Banding Method: Select from the following banding methods:
- Quartile (4 x 25% columns)
- Percentile (100 x 1% columns)
- Decile (10 x 10% columns)
- Other - Enter a specific number of bands using the field.
| Note: |
If the number of records in the column is not exactly divisible by the specified number of bands, then the excess number of records will be distributed evenly across the bands so that some bands may end up with more records than others. |
|
|
